Release 10.1A: OpenEdge Data Management:
Database Administration

Lock Table

Displays information about Lock Table Activity. The database engine stores record locks in the lock table. If a user tries to acquire a lock on a record, and the lock table overflows, the server aborts.

Figure 19–37 shows a sample Lock Table Activity display.

04/29/04 Activity: Lock Table 15:11:21 04/29/04 15:05 to 04/29/04 15:10 (5 min 14 sec)                               Total   Per Min    Per Sec    Per Tx Requests:     Share                      3715       710      11.83     61.92     Intent Share                  0         0       0.00      0.00     Exclusive                     8         2       0.03      0.13     Intent Exclusive              0         0       0.00      0.00     Share Intent Excl             0         0       0.00      0.00     Upgrade                       0         0       0.00      0.00     Record Get Lock            3505       670      11.16     58.42     Table Lock                   20         4       0.06      0.33     Record Lock                 198        38       0.63      3.30 Grants:     Share                      3715       710      11.83     61.92     Intent Share                  0         0       0.00      0.00     Exclusive                     8         2       0.03      0.13     Intent Exclusive              0         0       0.00      0.00     Share Intent Excl             0         0       0.00      0.00     Upgrade                       0         0       0.00      0.00     Record Get Lock            3505       670      11.16     58.42     Table Lock                   20         4       0.06      0.33     Record Lock                 198        38       0.63      3.30 Waits:     Share                         0         0       0.00      0.00     Intent Share                  0         0       0.00      0.00     Exclusive                     0         0       0.00      0.00     Intent Exclusive              0         0       0.00      0.00     Share Intent Excl             0         0       0.00      0.00     Upgrade                       0         0       0.00      0.00     Record Get Lock               0         0       0.00      0.00     Table Lock                    0         0       0.00      0.00     Record Lock                   0         0       0.00      0.00 Requests Cancelled                0         0       0.00      0.00 Downgrades                        0         0       0.00      0.00 Shared Find                       0         0       0.00      0.00 Exclusive Find                    0         0       0.00      0.00

Figure 19–37: PROMON Lock Table Activity display

The display lists the following operations:

Share requests — The number of user requests for share locks.
Exclusive requests — The number of user requests for exclusive locks.
Upgrade requests — The number of requests to upgrade a lock from shared lock to exclusive lock.
Rec Get requests — The number of granted record get locks.
Share grants — The number of granted share lock requests.
Exclusive grants — The number of granted exclusive lock requests.
Upgrade grants — The number of granted requests for lock upgrades.
Rec Get grants — The number of granted requests for record get locks.
Share waits — The number of times processes waited for share lock.
Exclusive waits — The number of times processes waited for an exclusive lock.
Upgrade waits — The number of times processes waited for upgrades.
Rec Get waits — The number of times processes waited for record gets.
Requests cancelled — The number of lock requests that were cancelled.
Downgrades — The number of locks downgraded.
Redundant requests — The number of requests for a lock already held.